﻿Imports sstools.GenericExcelExporter

<ExportEntity(
    WorkSheetName:="MapEntities Approach",
    BorderLineStyle:=sstools.GenericExcelExporter.XlLineStyle.xlContinuous,
    BorderWeight:=sstools.GenericExcelExporter.XlBorderWeight.xlThin,
    BorderColor:="Black"
    )>
Public Class CustomContact
    <ExportMember(Order:=2, BackgroundColor:="#ddc")>
    Public Property FirstName() As String

    <ExportMember(Order:=1, BackgroundColor:="#ddc")>
    Public Property LastName() As String

    <ExportMember(Order:=0, HAlign:=XlHAlign.xlHAlignLeft, BackgroundColor:="#eea")>
    Public Property ContactID() As Integer

    <ExportMember(Order:=3, HAlign:=XlHAlign.xlHAlignRight)>
    Public Property EmailAddress As String

    <ExportMember(Order:=4, ValueFormatterFuncName:="DateFormatter")>
    Public Property ModifiedDate As Date

    Public Shared Function DateFormatter(inp As Date) As String
        Return inp.ToString("yyyy-MM-dd")
    End Function
End Class